{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":144,"n_cols":15,"rows_kept":144,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,4,4,5],[4,13,4,14],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,5,6,5],[5,6,6,6],[5,7,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,14],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,7,5],[7,6,8,6],[7,7,7,10],[7,11,7,14],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[17,4,17,5],[17,13,17,14],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,5,19,5],[18,6,19,6],[18,7,19,8],[18,9,19,9],[18,10,19,10],[18,11,19,11],[18,12,19,12],[18,13,19,14],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,20,5],[20,6,21,6],[20,7,20,10],[20,11,20,14],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,28,6],[27,7,28,7],[27,8,28,8],[27,9,28,9],[27,10,28,10],[27,11,28,11],[27,12,28,12],[27,13,28,13],[27,14,28,14],[31,0,32,0],[31,1,32,1],[33,0,34,0],[33,1,34,1],[33,2,34,2],[33,3,33,5],[33,6,34,6],[33,7,33,10],[33,11,33,14],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[41,7,42,7],[41,8,42,8],[41,9,42,9],[41,10,42,10],[41,11,42,11],[41,12,42,12],[41,13,42,13],[41,14,42,14],[44,0,45,0],[44,1,45,1],[46,0,47,0],[46,1,47,1],[46,2,47,2],[46,3,46,5],[46,6,47,6],[46,7,46,10],[46,11,46,14],[53,2,54,2],[53,3,54,3],[53,4,54,4],[53,5,54,5],[53,6,54,6],[53,7,54,7],[53,8,54,8],[53,9,54,9],[53,10,54,10],[53,11,54,11],[53,12,54,12],[53,13,54,13],[53,14,54,14],[56,0,57,0],[56,1,57,1],[58,0,59,0],[58,1,59,1],[58,2,59,2],[58,3,58,5],[58,6,59,6],[58,7,58,10],[58,11,58,14],[65,2,66,2],[65,3,66,3],[65,4,66,4],[65,5,66,5],[65,6,66,6],[65,7,66,7],[65,8,66,8],[65,9,66,9],[65,10,66,10],[65,11,66,11],[65,12,66,12],[65,13,66,13],[65,14,66,14],[68,0,69,0],[68,1,69,1],[70,0,71,0],[70,1,71,1],[70,2,71,2],[70,3,70,5],[70,6,71,6],[70,7,70,10],[70,11,70,14],[78,2,79,2],[78,3,79,3],[78,4,79,4],[78,5,79,5],[78,6,79,6],[78,7,79,7],[78,8,79,8],[78,9,79,9],[78,10,79,10],[78,11,79,11],[78,12,79,12],[78,13,79,13],[78,14,79,14],[81,0,82,0],[81,1,82,1],[83,0,84,0],[83,1,84,1],[83,2,84,2],[83,3,83,5],[83,6,84,6],[83,7,83,10],[83,11,83,14],[90,2,91,2],[90,3,91,3],[90,4,91,4],[90,5,91,5],[90,6,91,6],[90,7,91,7],[90,8,91,8],[90,9,91,9],[90,10,91,10],[90,11,91,11],[90,12,91,12],[90,13,91,13],[90,14,91,14],[94,0,95,0],[94,1,95,1],[94,2,95,2],[94,3,94,5],[94,6,95,6],[94,7,94,10],[94,11,94,14],[101,2,102,2],[101,3,102,3],[101,4,102,4],[101,5,102,5],[101,6,102,6],[101,7,102,7],[101,8,102,8],[101,9,102,9],[101,10,102,10],[101,11,102,11],[101,12,102,12],[101,13,102,13],[101,14,102,14],[106,0,107,0],[106,1,107,1],[106,2,107,2],[106,3,106,5],[106,6,107,6],[106,7,106,10],[106,11,106,14],[117,0,118,0],[117,1,118,1],[117,2,118,2],[117,3,117,5],[117,6,118,6],[117,7,117,10],[117,11,117,14],[125,0,125,4],[126,1,128,3],[126,4,129,4],[142,0,143,0],[142,2,143,2],[142,3,143,3],[142,4,143,4],[145,0,145,1]]}
["Примерное меню завтраков для обучающихся 1-4-х классов                                                                          "]
["Основание:  "]
["1. Санитарно-эпидемиологические правила и нормы СанПиН 2,3/2,4,3590-20, Утверждены постановлением Главного государственного санитарного врача Российской Федерации от 27 октября 2020г. №32"]
["2.  Сборник рецептур на продукцию для обучающихся во всех образовательных учреждениях.                                                                                                                      Под ред. М.П.Могильного и  В.А.Тутельяна. - М.:ДеЛи плюс,2015 и 2017 года                                                                                                                                                                                                                                                                           "]
["День:","первый"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[223,"Запеканка из творога с повидлом",150,21.91,16.59,42,405,0.45,1.65,0.67,69.45,130.2,25.13,177.57,0.81]
[376,"Чай с сахаром",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
["б/н ","Батон нарезной",40,3,1.16,20.36,105.6,0.57,null,null,0.52,9.25,34.85,11.6,0.39]
[338,"Фрукты в ассортименте",120,0.48,0.48,11.76,56.4,0.02,13,null,0.26,20.8,14.3,11.7,2.86]
["б/н","Крекер",20,1.7,2.1,17,95.28,3.8,null,null,2,1.84,7.6,3.6,3]
[null,"соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C10:C14)","v":530},27.19,20.35,98.12,690.88,{"$f":"SUM(H10:H14)","v":4.84},{"$f":"SUM(I10:I14)","v":16.25},0.67,72.23,173.19,84.67999999999999,205.86999999999998,7.09]
[]
["День:  ","второй"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[175,"Каша «Дружба» молочная с маслом слив. (рис, пшено) ",250,7.6,12.25,39.15,296.88,0.1,0.8,20.9,"-",17.1,180.6,38.6,0.75]
[376,"Чай с сахаром",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
["б/н","Батон нарезной",40,3,1.16,20.36,105.6,0.57,null,null,0.52,9.25,34.85,11.6,0.39]
[338,"Фрукты в ассортименте",150,0.6,0.6,14.7,70.5,0.03,15,null,0.3,24,16.5,13.5,3.3]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C23:C26)","v":640},11.299999999999999,14.03,81.21,501.58000000000004,{"$f":"SUM(H23:H26)","v":0.7},{"$f":"SUM(I23:I26)","v":17.4},20.9,0.8200000000000001,61.45,234.75,65.1,4.47]
[]
[]
["День:  ","третий"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[401,"Оладьи ",105,7.42,7.86,36.5,282.85,null,1.76,null,null,33.38,2.7,49.77,2.5]
[null,"с повидлом",45,0,0,29.25,117,0.3,0.27,null,null,0.63,0.5,0.81,3.24]
[376,"Чай с сахаром",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
["б/н","Батон нарезной",40,3,1.16,20.36,105.6,0.57,null,null,0.52,9.25,34.85,11.6,0.39]
[338,"Фрукты в ассортименте",150,0.6,0.6,14.7,70.5,0.03,15,null,0.3,24,16.5,13.5,3.3]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C36:C40)","v":540},11.12,9.639999999999999,107.81,604.5500000000001,{"$f":"SUM(H36:H40)","v":0.8999999999999999},{"$f":"SUM(I36:I40)","v":18.63},0,0.8200000000000001,78.36000000000001,57.35,77.08000000000001,9.46]
[]
["День:  ","четвертый"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р",null,"Fe"]
[204,"Макароны отварные с сыром",190,12.86,15.12,32.41,317.64,0.07,0.2,109.44,0.8,280.4,192.6,19.28,1.2]
[376,"Чай с сахаром",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
["б/н","Батон нарезной",40,3,1.16,20.36,105.6,null,null,0.52,9.25,34.85,11.6,0.39]
[338,"Фрукты в ассортименте",150,0.6,0.6,14.7,70.5,0.03,15,null,0.3,24,16.5,13.5,3.3]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C49:C52)","v":580},16.56,16.9,74.47,522.34,{"$f":"SUM(H49:H52)","v":0.1},{"$f":"SUM(I49:I52)","v":16.8},109.96,10.350000000000001,350.35,223.5,34.57,4.529999999999999]
[]
["День:  ","пятый"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[173,"Каша вязкая молочная пшенная ",230,7.93,12.19,70.81,392.03,0.18,null,5.75,0.14,4.69,150.69,{"v":51.8,"d":"51.80"},{"v":2.9,"d":"2.90"}]
[382,"Какао с молоком",200,4.08,3.54,17.58,{"v":118.6,"d":"118.60"},0.05,{"v":1.3,"d":"1.30"},{"v":24.4,"d":"24.40"},null,{"v":133.2,"d":"133.20"},{"v":124.5,"d":"124.50"},{"v":25.5,"d":"25.50"},{"v":2,"d":"2.00"}]
["б/н ","Батон нарезной",40,3,1.16,20.36,105.6,null,null,0.52,9.25,34.85,11.6,0.39]
[null,"Вафли",40,1.12,9.8,20.4,185.5,0.05,null,38.4,0.6,66.6,46.4,8,0.5]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C61:C64)","v":{"v":510,"d":"510.00"}},16.13,26.69,129.15,801.73,{"v":0.27999999999999997,"d":"0.28"},{"v":1.3,"d":"1.30"},69.07,9.99,{"v":239.33999999999997,"d":"239.34"},333.19,85.69,{"v":5.4,"d":"5.40"}]
[]
["День:  ","шестой"]
["Неделя: ","вторая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[210,"Омлет натуральный",150,13.94,24.82,2.64,289.65,0.11,3.75,97.82,0.006,178.6,231,59.57,1.23]
[376,"Чай с сахаром",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
[338,"Фрукты в ассортименте",150,0.6,0.6,14.7,70.5,0.03,15,null,0.3,24,16.5,13.5,3.3]
[" б/н","Хлеб ржаной",30,1.4,0.47,7.8,42,0.04,"-","-",0.36,9.2,42.4,10,1.24]
["б/н","Батон нарезной",40,3,1.16,20.36,105.6,0.57,null,null,0.52,9.25,34.85,11.6,0.39]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C73:C77)","v":570},19.04,27.07,52.5,536.35,{"$f":"SUM(H73:H77)","v":0.75},{"$f":"SUM(I73:I77)","v":20.35},97.82,1.186,232.14999999999998,327.55,96.07,6.1899999999999995]
[]
["День:  ","седьмой"]
["Неделя: ","вторая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[173,"Каша гречневая молочная",230,9.04,13.44,50.14,358,0.21,1.64,2.9,null,183.88,245,99.23,2.9]
[379,"Кофейный напиток с молоком",200,3.17,2.68,15.96,100.6,"-",2.55,"-",0.01,13.78,3.96,2.16,0.32]
["б/н","Батон нарезной",40,3,1.16,20.36,105.6,null,null,0.52,9.25,34.85,11.6,0.39]
["б/н","Пряники",40,2.24,2,30.52,144.8,2.12,null,null,6.4,0.44,2.52,0.92,0.76]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C86:C89)","v":510},17.45,19.28,116.97999999999999,709,{"$f":"SUM(H86:H89)","v":2.33},{"$f":"SUM(I86:I89)","v":4.1899999999999995},3.42,15.66,232.95,263.08,102.7,3.9799999999999995]
[]
["День ","восьмой"]
["неделя ","вторая"]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[278,"Тефтели из птицы с соусом",90,6.65,7.37,8.77,128.46,0.2,0.7,27.2,55.4,48.4,64.8,17.9,2.9]
[302,"Рис отварной",200,4.87,7.15,48.91,279.6,0.03,null,null,0.36,1.82,81.26,21.79,0.7]
[376,"Чай с сахаром",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
[" б/н","Хлеб ржаной",30,1.4,0.47,7.8,42,0.04,"-","-",0.36,9.2,42.4,10,1.24]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C97:C100)","v":520},13.02,15.01,72.47999999999999,478.6600000000001,{"$f":"SUM(H97:H100)","v":0.27},{"$f":"SUM(I97:I100)","v":2.3},27.2,56.12,70.52,191.26000000000002,51.089999999999996,4.869999999999999]
[]
["День ","девятый"]
["неделя ","вторая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[204,"Макароны отварные с сыром",190,12.86,15.12,32.41,317.64,0.07,0.2,109.44,0.8,280.4,192.6,19.28,1.2]
[376,"Чай с сахаром",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
["б/н ","Батон нарезной",40,3,1.16,20.36,105.6,null,null,0.52,9.25,34.85,11.6,0.39]
[338,"Фрукты в ассортименте",100,0.4,0.4,9.8,47,0.02,10,"-",0.2,16,11,9,2.2]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C109:C112)","v":530},16.36,16.699999999999996,69.57,498.84000000000003,{"$f":"SUM(H109:H112)","v":0.09000000000000001},{"$f":"SUM(I109:I112)","v":11.8},109.96,10.25,342.35,218,30.07,3.43]
[]
["День","десятый"]
["Неделя ","вторая"]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[398,"Блинчики с фруктовой начинкой  с соусом из свежезамороженных ягод 180/30",210,5.9,8.09,121.3,558.7,0.1,16.1,63,null,41.3,80.2,30.4,2.2]
[376,"Чай с сахаром  ",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
["б/н","Фрукты (яблоки)",100,0.4,0.4,9.8,47,0.02,10,"-",0.2,16,11,9,2.2]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C120:C122)","v":510},6.4,8.51,138.10000000000002,634.3000000000001,0.12000000000000001,27.700000000000003,63,0.2,68.4,94,40.8,4.43]
[]
["Основные показатели в пищевых веществах и энергетической ценности   (к СанПиН 2.3/2.4.3590-20)"]
["                Основные показатели","Пищевые вещества (г)",null,null,"Энергетическая ценность (ккал)"]
[]
[" Дни по меню"]
[null,"Б","Ж","У"]
["1 день",27.19,20.35,98.12,690.88]
["2 день",11.299999999999999,14.03,81.21,501.58000000000004]
["3 день",11.12,9.639999999999999,107.81,604.5500000000001]
["4 день",16.56,16.9,74.47,522.34]
["5 день",16.13,26.69,129.15,801.73]
["6 день",19.04,27.07,52.5,536.35]
["7 день",17.45,19.28,116.97999999999999,709]
["8 день",13.02,15.01,72.47999999999999,478.6600000000001]
["9 день",16.36,16.699999999999996,69.57,498.84000000000003]
["10 день",6.4,8.51,138.10000000000002,634.3000000000001]
["Итого за весь период:",{"$f":"SUM(B131:B140)","v":154.57000000000002},{"$f":"SUM(C131:C140)","v":174.17999999999998},940.39,5978.2300000000005]
["Итого в среднем за 1день (прием пищи):",{"$f":"SUM(B141/10)","v":15.457000000000003},{"$f":"SUM(C141/10)","v":17.418},94.039,597.8230000000001]
["Завтрак – 20-25% от нормы","20-25% -  от нормы                - 77.00, составит ","20-25% -  от нормы                - 79.00, составит                15.80 – 19.75 "," 20-25% -  от нормы                - 335.00, составит               67.00 – 83.75","20-25% -  от нормы                                                          - 2350.00, составит                                                                               470.00 – 587.50"]
[null,"15.40 – 19.25  "]

{"sheet":"Лист2","index":1,"n_rows":28,"n_cols":1,"rows_kept":28,"merged":[[5,0,6,0],[20,0,21,0],[27,0,28,0]]}
[2.4]
[0.2]
[0.34]
[2.2]
[]
[{"$f":"SUM(A1:A4)","v":5.140000000000001}]
[]
[]
[]
[0.75]
[2]
[0.33]
[0.2]
[]
[]
[2.5]
[1.8]
[0.33]
[0.2]
[]
[4.83]
[]
[]
[1.8]
[0.03]
[2.9]
[]
[4.73]